CREATE TABLE [dbo].[Location]
(
[LocationKey] [uniqueidentifier] NOT NULL,
[ContactKey] [uniqueidentifier] NOT NULL,
[LocationName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LocationDescription] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationStatusCode] [nchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MarkedForDeleteOn] [datetime] NULL,
[UpdatedOn] [datetime] NULL,
[UpdatedByUserKey] [uniqueidentifier] NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Location] ADD CONSTRAINT [PK_Location_LocationKey] PRIMARY KEY CLUSTERED ([LocationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Location_ContactKey] ON [dbo].[Location] ([ContactKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Location_CreatedByUserKey] ON [dbo].[Location] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Location_LocationStatusCode] ON [dbo].[Location] ([LocationStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Location_UpdatedByUserKey] ON [dbo].[Location] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Location] ADD CONSTRAINT [FK_Location_ContactMain_Contact] FOREIGN KEY ([ContactKey]) REFERENCES [dbo].[ContactMain] ([ContactKey])
GO
ALTER TABLE [dbo].[Location] ADD CONSTRAINT [FK_Location_LocationStatusRef] FOREIGN KEY ([LocationStatusCode]) REFERENCES [dbo].[LocationStatusRef] ([LocationStatusCode])
GO
ALTER TABLE [dbo].[Location] ADD CONSTRAINT [FK_Location_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[Location] ADD CONSTRAINT [FK_Location_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO